[dbo].[BatchSetup]

Property	Value
Created	10:31:14 AM Tuesday, March 02, 2010
Last Modified	3:54:38 PM Wednesday, March 07, 2012

	Name	Data Type	Max Length (Bytes)	Default
	BatchSetupKey	uniqueidentifier	16
$Indexes IX_BatchSetup: DepartmentGroupKey\WorkObjectName$	WorkObjectName	nvarchar(100)	200
	PostObjectName	nvarchar(100)	200
$Indexes IX_BatchSetup: DepartmentGroupKey\WorkObjectName$	DepartmentGroupKey	uniqueidentifier	16
	BatchNumberFormat	nchar(20)	40
	BatchTypeCode	int	4
	BatchTypeName	nvarchar(50)	100
	AutoPostFlag	bit	1	((0))
	AutoCreateFlag	bit	1	((0))
	CreatedByUserKey	uniqueidentifier	16
	CreatedOn	datetime	8
	UpdatedByUserKey	uniqueidentifier	16
	UpdatedOn	datetime	8
	SystemEntityKey	uniqueidentifier	16
	MarkedForDeleteOn	datetime	8

	Name	Columns	Unique
	PK_BatchSetup	BatchSetupKey
	IX_BatchSetup	DepartmentGroupKey, WorkObjectName
	IX_BatchSetup_BatchTypeCode	BatchTypeCode
	IX_BatchSetup_CreatedByUserKey	CreatedByUserKey
	IX_BatchSetup_SystemEntityKey	SystemEntityKey
	IX_BatchSetup_UpdatedByUserKey	UpdatedByUserKey

Name	Columns
FK_BatchSetup_SystemEntity	SystemEntityKey->[dbo].[SystemEntity].[SystemEntityKey]
FK_BatchSetup_UserMain_CreatedBy	CreatedByUserKey->[dbo].[UserMain].[UserKey]
FK_BatchSetup_UserMain_UpdatedBy	UpdatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[BatchSetup]
(
[BatchSetupKey] [uniqueidentifier] NOT NULL,
[WorkObjectName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PostObjectName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DepartmentGroupKey] [uniqueidentifier] NULL,
[BatchNumberFormat] [nchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BatchTypeCode] [int] NOT NULL,
[BatchTypeName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AutoPostFlag] [bit] NOT NULL CONSTRAINT [DF_BatchSetup_AutoPostFlag] DEFAULT ((0)),
[AutoCreateFlag] [bit] NOT NULL CONSTRAINT [DF_BatchSetup_AutoCreateFlag] DEFAULT ((0)),
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[SystemEntityKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[BatchSetup] ADD CONSTRAINT [PK_BatchSetup] PRIMARY KEY CLUSTERED ([BatchSetupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_BatchSetup_BatchTypeCode] ON [dbo].[BatchSetup] ([BatchTypeCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_BatchSetup_CreatedByUserKey] ON [dbo].[BatchSetup] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_BatchSetup] ON [dbo].[BatchSetup] ([DepartmentGroupKey], [WorkObjectName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_BatchSetup_SystemEntityKey] ON [dbo].[BatchSetup] ([SystemEntityKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_BatchSetup_UpdatedByUserKey] ON [dbo].[BatchSetup] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BatchSetup] ADD CONSTRAINT [FK_BatchSetup_SystemEntity] FOREIGN KEY ([SystemEntityKey]) REFERENCES [dbo].[SystemEntity] ([SystemEntityKey])
GO
ALTER TABLE [dbo].[BatchSetup] ADD CONSTRAINT [FK_BatchSetup_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[BatchSetup] ADD CONSTRAINT [FK_BatchSetup_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO